Guest User

Untitled

a guest
Oct 15th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. Table 1: Assets (asset_number,type,serial_number,desk_id)
  2. Table 2: Desks (id,desk_name,location_name)
  3.  
  4. SELECT [Assets].[asset_number] As "Asset Number", [Assets].[type] As "Type", [Assets].[serial_number] As "Serial Number", [Desks].[desk_name] As "Desk", [Desks].[location_name] As "Location"
  5. FROM [Assets]
  6. LEFT JOIN [Desks] ON [Assets].[desk_id]=[Desks].[id];
Add Comment
Please, Sign In to add comment