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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

URGENT PLEASE HELP

Status
Not open for further replies.
Gregsy35

Gregsy35

Programmer
Dec 5, 2000
21
CA
if a run quite a complex query adn get a set of results
for example a set of serialnumbers how can i run a query that will only work for that set of serial numbers, in case of select from a table but only from those set of numbers
thanks guys
 
Sort by date Sort by votes
Use the query which you already have in a left join on hte serial numbers.

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SoLost1
  • Locked
  • Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
150
dhookom
dhookom
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
148
serino
serino
eerich
  • Locked
  • Question
IIF Help on complex query
Replies
5
Views
161
Andrzejek
Andrzejek
WimDC
  • Locked
  • Question
Help on grouping by TIME Range
Replies
1
Views
129
dhookom
dhookom
K. Reed
  • Locked
  • Question
Can anyone help me figure out what i've done wrong?
Replies
18
Views
165
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top