Ed Hawke
<edward.ha...@hawkeyeinnovations.co.uk> wrote:
> To clarify this (I hope) if my table set-up is:
>
> Table A:
> ID Column1 Column2 Column3 Column4
> 1 12345 6789 21 23
> 2 16321 5876 22 21
> 3 31456 9108 22 24
>
> Table B:
> ID Column1 Column2
> 21 31 42
> 22 31 41
> 23 33 43
> 24 32 41
>
> Table C:
> ID Column1
> 31 Name1
> 32 Name2
> 33 Name3
>
> Table D:
> ID Column1
> 41 Info1
> 42 Info2
> 43 Info3
>
> How would I select A.ID, A.Column1, A.Column2, C.Column1, D.Column1,
> C.Column1, D.Column1 where the first set of info from C and D is based
> on the ID contained in A.Column3, and the second set on the ID in
> A.Column4?
select * from A
join B b1 on (A.Column3 = b1.ID)
join C c1 on (b1.Column1 = c1.ID)
join D d1 on (b1.Column2 = d1.ID)
join B b2 on (A.Column4 = b2.ID)
join C c2 on (b2.Column1 = c2.ID)
join D d2 on (b2.Column2 = d2.ID);
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
