I am trying to pull data from three tables but running into a relation issues. Table1: Customer Table. Table 2: Invoice Table Table 3: Invoice Detail Table On table 1 the customer number column is "BPCNUM_0" On Table 2: The customer number column is "BPR_0" On Table 3: The customer number column is "BPCINV_0" Any idea how I can connect them to pull the data?
What would be the SQL query to connect them to be able to pull the data?
There you go 
SELECT TOP 1000
SIH.NUM_0
, BPC.BPCNUM_0
, BPC.BPCNAM_0
FROM SEED.SINVOICE AS SIH WITH (NOLOCK)
INNER JOIN SEED.SINVOICED AS SID WITH (NOLOCK)
ON SIH.NUM_0 = SID.NUM_0
INNER JOIN SEED.BPCUSTOMER AS BPC WITH (NOLOCK)
ON BPC.BPCNUM_0 = SIH.BPR_0
Regards,
Hugo
Hugo Sanguino Thanks for the query. I wanted to pull the information in the following way. But I believe I am not declaring something correctly.
Do you know how I can correct this and also I wanted to add the customer table so I can pull more information.