Stored Procedure select from multiple tables, variables
Posted on 2007-10-01
I have to tables, well I actually have more, but only 2 that matter for this question. One is tbl_poVendors, and the other is tbl_poHeader. I am trying to select the vendor name, address, city, state, zip from the tbl_poVendors, where the poRequisitionNumber, and vendorid match certain numbers in the tbl_poHeader table. Can someone help me? I want to do this in a stored procedure if possible, and I would like to avoid creating a view (if I don't need to) if so, then so be it. Are there any pros/cons to a view? Any help would be MUCH appreciated...