2 Replies - 523 Views - Last Post: 22 May 2016 - 11:01 AM

#1 t3cho  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 217
  • Joined: 27-May 14

Link from main table

Posted 22 May 2016 - 10:18 AM

Help with query

Lets say i have three tables for example Main,Items,ItemsItems

Posted Image

Now my output results needs to go from the Main table and linking other tables which means i cant use query as i used to write such as.

From ItemsItems
LEFT JOIN Items
LEFT JOIN Main
WHERE Main.Id =  ....


My query needs to go

From Main..
JOIN Items .
JOIN ...

so i could get at the end condition such as WHERE Main.Id =

Which kind of linking i need to use here ??

Is This A Good Question/Topic? 0
  • +

Replies To: Link from main table

#2 andrewsw  Icon User is online

  • lashings of ginger beer
  • member icon

Reputation: 6340
  • View blog
  • Posts: 25,573
  • Joined: 12-December 12

Re: Link from main table

Posted 22 May 2016 - 10:24 AM

You still use joins:

Join Fundamentals
Using Joins

You just need to study them to get the syntax correct.

BTW ItemItems is not a great name.

My tutorials:

Table Joins
Join Three Tables
Was This Post Helpful? 1
  • +
  • -

#3 andrewsw  Icon User is online

  • lashings of ginger beer
  • member icon

Reputation: 6340
  • View blog
  • Posts: 25,573
  • Joined: 12-December 12

Re: Link from main table

Posted 22 May 2016 - 11:01 AM

I have modified your title from "Linq" to "Link" as it is nothing to do with LINQ ;)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1