Combine Two Selects...

[drbigfresh]

I am doing a select twice, each time checking for a different flag. I am wondering if there is anyway to combine the two selects so I am only making one trip to the database. The selects looks like this:

 

Select 1:

select wedding_guest.fname, wedding_guest.mi, wedding_guest.lname, wedding_prefix.prefix, wedding_guest.type from wedding_guest left outer join wedding_prefix on wedding_guest.prefix = wedding_prefix.id where ( wedding_guest.InviteID = 1 ) and ( weddingid = '1) and ( type = 'P' )

 

Select 2:

select wedding_guest.fname, wedding_guest.mi, wedding_guest.lname, wedding_prefix.prefix, wedding_guest.type from wedding_guest left outer join wedding_prefix on wedding_guest.prefix = wedding_prefix.id where ( wedding_guest.InviteID = 1 ) and ( weddingid = '1) and ( type = 'S' )

 

The only difference is the type flag, in one I am looking for the 'P' value and the other the 'S' value. Is it possible to combine these two?

 

Thanks!

[js_280]

Okay...maybe I'm making this too simple, but are you simply wanting to pull all records with with inviteID = 1, weddingid = 1, and all records with a type of P or S?

 

If so...

 

select wedding_guest.fname, wedding_guest.mi, wedding_guest.lname, wedding_prefix.prefix, wedding_guest.type from wedding_guest left outer join wedding_prefix on wedding_guest.prefix = wedding_prefix.id where ( wedding_guest.InviteID = 1 ) and ( weddingid = '1) and (type = 'P' OR type = 'S' );