>Then, your stored proc could look something like this:
>

>CREATE PROCEDURE dbo.joinProc
>	(
>		@idList varchar(2000) = ""
>	)
>as
>	set nocount on
>
>	declare @query varchar(2500)
>
>	set @query = "SELECT table1.fieldList, table2.fieldList "
>	set @query = @query + "FROM table1 "
>	set @query = @query + "INNER JOIN table2 "
>	set @query = @query + "ON table1.id = table2.id "
>	set @query = @query + "WHERE table2.id IN (" + @idList + ")"
>
>	execute (@query)
>return
>

Is there a way that I could have that stored procedure to exist within native VFP code? I mean, I don't want to store that on the backend. I would like to execute such procedure to achieve the goal but by code only.