braccetto
Создатель
- Регистрация
- 7 Фев 2018
- Сообщения
- 27
- Реакции
- 68
- Автор темы
- #1
Hi Friends,
for an alternative project i'm triyng to query directly the 2016 tecdoc db
to show me all articles compatibles with every car+description+link to image
and then to save result as txt/cvs/xls file
someone could help me in that???
i tried a query like this but show me 0 results
for an alternative project i'm triyng to query directly the 2016 tecdoc db
to show me all articles compatibles with every car+description+link to image
and then to save result as txt/cvs/xls file
someone could help me in that???
i tried a query like this but show me 0 results
SELECT DISTINCT
`LINK_ART`.`LA_ART_ID`
FROM `LINK_LA_TYP`
JOIN `LINK_ART`
ON `LINK_ART`.`LA_ID` = `LINK_LA_TYP`.`LAT_LA_ID`
AND `LINK_ART`.`LA_GA_ID` = `LINK_LA_TYP`.`LAT_GA_ID`
WHERE `TOF_LINK_LA_TYP`.`LAT_TYP_ID` = $typ
`LINK_ART`.`LA_ART_ID`
FROM `LINK_LA_TYP`
JOIN `LINK_ART`
ON `LINK_ART`.`LA_ID` = `LINK_LA_TYP`.`LAT_LA_ID`
AND `LINK_ART`.`LA_GA_ID` = `LINK_LA_TYP`.`LAT_GA_ID`
WHERE `TOF_LINK_LA_TYP`.`LAT_TYP_ID` = $typ