467,202 Members | 1,018 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,202 developers. It's quick & easy.

Nested selects

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
  • viewed: 1432
Share:
1 Reply
8TB
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.

Similar topics

2 posts views Thread by Jamie Townsend | last post: by
11 posts views Thread by mlf | last post: by
reply views Thread by DG | last post: by
9 posts views Thread by deko | last post: by
1 post views Thread by Goldie | last post: by
1 post views Thread by Grant | last post: by
2 posts views Thread by Me LK | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.