Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table 1: Assets (asset_number,type,serial_number,desk_id)
- Table 2: Desks (id,desk_name,location_name)
- 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"
- FROM [Assets]
- LEFT JOIN [Desks] ON [Assets].[desk_id]=[Desks].[id];
Add Comment
Please, Sign In to add comment