|
Тема |
left join, union, mssql |
|
Автор | bgy (Нерегистриран) | |
Публикувано | 16.03.03 12:15 |
|
|
hi, imam slednia problem:
2 tablici ot koito triabva da izvadia 1 result
[tbl1]
id
name
address
[tbl2]
id
city
state
zip
country
id pri tbl1 otgovaria na id v tbl2
opitah s UNION, bez uspeh; s LEFT JOIN stava, no ne moga da polzvam WHERE
clause neshto (osnovno tuk e problema)... mysql-a e 4.0.10. blagodaria za pomoshtta.
i oshte neshto :)
koi e latest MSSQL i otkyde moga da go drypna? big 10x.
|
| |
left join, union, mssql
| bgy
| 16.03.03 12:15 |
Re: left join, union, mssql
| Topбaлaн
| 16.03.03 17:28 |
Re: left join, union, mssql
| $burov
| 16.03.03 20:39 |
Re: left join, union, mssql
| Topбaлaн
| 16.03.03 22:50 |
Re: left join, union, mssql
| phpGuru
| 17.03.03 13:16 |
Re: left join, union, mssql
| phpGuru
| 17.03.03 13:21 |
left [outer] join
| baj L\bo
| 17.03.03 19:43 |
че е прав - прав е гурото...
| Topбaлaн
| 17.03.03 23:07 |
Re: left join, union, mssql
| jkl
| 23.03.03 15:52 |
Re: кажи, че си забравил LEFT за да се успокоим
| salle
| 17.03.03 15:02 |
|
|
|
|