Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Distinguishing records from which select statement using UNION in SQL
I just got my solution: SELECT Ord_Order_No, Ord_Order_Date, Ord_Cust_No, 'O' as Type FROM ORDERS1 WHERE Ord_Rec_No = ' ' AND (Ord_Order_No BETWEEN ' ' AND 'ZZZZZZ') AND ORD_CUST_PO_NO = '1234' UNION SELECT Hi_Invoice_No as Ord_Order_No, Hi_Invoice_Date as Ord_Order_Date, Hi_Cust_No as...- lsmeteor
- Post #2
- Forum: Pervasive: Pervasive.SQL
-
Distinguishing records from which select statement using UNION in SQL
Hello all, I just found the perfect sql statement (gives me what I am loking for) except for one little detail. I am querying the order and invoice tables. I can't differientiate between records and see where they came from. I am using Pervasive 2000i SP4. Here is the sql statement used: code...- lsmeteor
- Thread
- Replies: 1
- Forum: Pervasive: Pervasive.SQL
