HowTo consolidate SQL statements... 1

[sqlsamurai]

How would I consolidate these three statements? The only difference is one of the fields in the WHERE statements. I'm using SQL Server 2005 if that makes any difference.

SELECT Inventory.*, Products.IjoistTypeID 
FROM Products INNER JOIN Inventory ON Products.ProductID = Inventory.ProductID 
WHERE (((Inventory.PurchaseOrderID)=" & al_MasterID & ") AND ((Products.LumberTypeID)=3))

SELECT Inventory.*, Products.IjoistTypeID 
FROM Products INNER JOIN Inventory ON Products.ProductID = Inventory.ProductID 
WHERE (((Inventory.ProductionID)=" & al_MasterID & ") AND ((Products.LumberTypeID)=3))

SELECT Inventory.*, Products.IjoistTypeID 
FROM Products INNER JOIN Inventory ON Products.ProductID = Inventory.ProductID 
WHERE (((Inventory.ReturnID)=" & al_MasterID & ") AND ((Products.LumberTypeID)=3))

Thanks

 

[bborissov]

SELECT Inventory.*, Products.IjoistTypeID
FROM Products INNER JOIN Inventory ON Products.ProductID = Inventory.ProductID
WHERE (Inventory.PurchaseOrderID = al_MasterID  OR
       Inventory.ProductionID    = al_MasterID  OR
       Inventory.ReturnID        = al_MasterID) AND
      (Products.LumberTypeID)=3)

Is that what you want?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[sqlsamurai]

Yes it is... I guess I was making it more complicated that it was. ;-) Star for you.

 

[bborissov]

Just saw a typo in my example. Remove closing bracket before equal sign ;-)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.