SHAPE command chokes SQL Engine

[jtrapat1]

I'm trying to run this parent/child sql SHAPE command against SQL Server 7 thru query analyzer but I'm getting an error:

[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

The query is:

SHAPE {SELECT BillNum, Sponsor, Title, CommitteeDate, OriginalCommittee FROM Bill} AS rsBill
APPEND ({SELECT BillNum, Requester FROM Requests}
RELATE BillNum TO BillNum ) AS rsRequests

Can anyone help?
I tried it with dbo. in front of each field but it gave me the same error.

Thanks in advance.

 

[Cagliostro]

In chape and in appent you should have the same number of selected items. John Fill

ivfmd@mail.md