Tamir Hazan

Tamir Hazan

  • NA
  • 15
  • 667

query - two different tables

Dec 19 2017 8:01 AM
Hey!
 
I want to make join from two different tables (with no connection between them):
 
Parkinglot (parkingLotID, addressParkingLot, statusParkingLot)
 
PublicParking (publicParkingID, addressPublicParking, statusParking).
 
And I want to write a query that returns all the parkings that are available - based on their status (Parkinglot & PublicParking).
 
I've read that I need to do full outer join (make one big table) and only then I can write the query.
 
I need to write the query in linq.
 
I really need your help about this query and about the full outer join (if it's right)
 
TNX! 

Answers (8)