By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Nested selects

P: 1
I need away to search a table that has a record that holds two types of data onhands and House bills, but only give back the one. This one will be the firt match.
For example I can have a shipment that will have an obslote flag at an onhand level and at a house bill level on want to see the first record.
I have tryed to join both tavles then use a case stament to look at the results and this did not work.

I only want the first occuracne and can not get any results. Should i try a nested select?
Jul 22 '07 #1
Share this Question
Share on Google+
1 Reply


10K+
P: 13,264
I need away to search a table that has a record that holds two types of data onhands and House bills, but only give back the one. This one will be the firt match.
For example I can have a shipment that will have an obslote flag at an onhand level and at a house bill level on want to see the first record.
I have tryed to join both tavles then use a case stament to look at the results and this did not work.

I only want the first occuracne and can not get any results. Should i try a nested select?
Can you give your table structure and an example?
Jul 23 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.