Member Avatar for yonker

Table 1 has fields: A, B, C, Table 2, there are fields: D, E, F, Table 3 has fields: G, H, I

Connect the condition that A = D and F = I

Please provide a look at Table A left join B, C of the SQL statement

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by jbisono
Member Avatar for jbisono 
select *
from 1 
left outer join 2 on 1.a = 2.d
left outer join 3 on 2.f = 3.i
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.