1 2 3 4 5 6 7
| SELECT DISTINCT [Table_0].CHAMP1, [Table_0].CHAMP2, [Table_0].CHAMP3, [Table_0].CHAMP4, [Table_0].CHAMP5
FROM [Table_0]
WHERE ((([Table_0].CHAMP5)<>"*")) AND ((([Table_0].CHAMP5)<>""))
ORDER BY [Table_0].CHAMP1, [Table_0].CHAMP2, [Table_0].CHAMP3, [Table_0].CHAMP4, [Table_0].CHAMP5 UNION SELECT [Table_0].CHAMP1, [Table_0].CHAMP2, [Table_0].CHAMP3, [Table_0].CHAMP4, [star_values].Star_values
FROM [Table_0], [star_values]
WHERE ((([Table_0].CHAMP5)="*"))
ORDER BY [Table_0].CHAMP1, [Table_0].CHAMP2, [Table_0].CHAMP3, [Table_0].CHAMP4, [Table_0].CHAMP5; |
Partager