Viewing 5 posts - 16 through 20 (of 20 total)
select *
from test MAIN
where A1 in
(select A1
from (select A1, A2
from test...
October 14, 2011 at 6:41 pm
Assuming that trans_date is coming Table3, please try this..
select JB.id1, JB.id2, JB.stat, JB.item, JR.oper_num, JR.complete, JR.qty_complete, JT.max_trans_date
from TABLE1 JB
join TABLE2 JR on...
October 13, 2011 at 6:47 pm
I may have misunderstood your question.
Could you please post the following, if you can
1. Test data you used for testing
2. Actual Output from the query I sent you
3. Expected...
October 12, 2011 at 3:57 pm
small correction to my previous reponse. remove T1.reseller_id = BP.reseller_id from the join condition in the last query..
Sorry for the confusion..
Try this one..
SELECT *
FROM table1 T1
INNER JOIN (SELECT...
October 12, 2011 at 8:43 am
Try this one..
SELECT *
FROM table1 T1
INNER JOIN (SELECT price
...
October 12, 2011 at 8:40 am
Viewing 5 posts - 16 through 20 (of 20 total)