Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
8
Reply
query - two different tables
Tamir Hazan
Dec 19 2017 8:01 AM
211
Reply
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!
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
8
)
Next Recommended Forum
How to convert SQL to LinQ
Finding difference in two strings.