Newbie: Query match one field in all tables.

[raboo2u]

I have the following tables/Fields

First_Time_Buyer(table)

Fields

User_Id
Dollar_Loss
Potential_loss

Coupon_Seller (Table)

Fields

User_Id
Total_Purch
Num_Loss
Dollar_Loss
Dollar_Prevented
Num_Prevented

Fraud_Buyer (table)

Fields

User_Id
Dollar_Loss

I want to match any User_Id that is in every table and return all values from every table for that User_id. I am new to this and would like to create a query for this. Can anyone help?

 

[JamesLean]

SELECT *
FROM First_Time_Buyer t1
  JOIN Coupon_Seller t2 ON t1.user_id = t2.user_id
  JOIN Fraud_Buyer t3 ON t1.user_id = t3.user_id

--James