Josh,

I think I'm losing it. I had been getting some type of error like "bad command", but when I just tried it again, it worked! Sorry about that!

Mandy

>Mandy,
>
>This should work. What happens when you use the view? Do you get an error message, or just not the results you expected?
>
>>I'm creating some views with the CREATE SQL VIEW commands, including some JOINs. Is it possible to create a JOIN with an AND?
>>
>>eg. CREATE SQL VIEW lvtest AS SELECT System.acode, System.hwid, ;
>> System.vendname AS sysvend, System.model AS sysmodel, ;
>> SysSW.swname, SysSW.version AS swversion, ;
>> SysSW.descrip AS swdescrip;
>> FROM System ;
>>--> LEFT JOIN SysSW ON System.acode = SysSW.acode AND ;
>>--> System.hwid = SysSW.hwid ;
>> WHERE System.acode = ?caid ;
>> ORDER BY System.hwid
>>
>>This won't work for me, but is there something along this logic I can use??
>>
>>MTIA!
>>
>>Mandy