|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi,
I have question for getting data as cartesian . Tables are Word,Noun,Adj word have word field (PK) verb have word field (FK) and verb adj have word field (FK) and adj when executing query SELECT [word].[word], [verb].[verb], [adj].[adj] FROM (word LEFT JOIN adj ON [word].[word]=[adj].[word]) LEFT JOIN verb ON [word].[word]=[verb].[word]; word verb adj preconceived presuppose consider in advance preconceived form an opinion in advance consider in advance preconceived presuppose presupposed preconceived form an opinion in advance presupposed but I want query output like preconceived presuppose consider in advance preconceived form an opinion in advance presupposed is it possible in MS ACCESS .. Please suugest query. Regards Rupam |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > multiple table cartesian query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|