sql query need a help.
        Posted  
        
            by benjamin button
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by benjamin button
        
        
        
        Published on 2010-04-29T14:16:36Z
        Indexed on 
            2010/04/29
            14:47 UTC
        
        
        Read the original article
        Hit count: 273
        
If i have a table with two fields.customer id and order. let's say i have in total order ID 1,2,3,4
all the customer can have all the four orders.like below
    1234 1
    1234 2
    1234 3
    1234 4
    3245 3
    3245 4
    5436 2
    5436 4
you can see above that 3245 customer doesnt have order id 1 and 2. how could i print in the query output like
3245 1
3245 2
5436 1
5436 3
EDIT: i dont order table but i have list of order's like we can hard code it in the query(1,2,3,4) i dont have an orders table.
© Stack Overflow or respective owner