|
-
Nov 6th, 2001, 10:32 AM
#1
Thread Starter
Lively Member
Need help with SQL
I read a few weeks ago a post in which someone published a link to a site that offered a SQL generator that uses english like language to produce a SQL query. I don't remember who published it, but, PLEASE I need that link now.
I have to make a lot of queries using SQL SELECT statements and I do not have the time to use Access to generate buggy code and I neither have the time to guess the queries.
-------------------------------------------------------------------------------
The first query I need to produce should be able to get all the records from a table that contains images but the images should be of the same user. I mean:
Table 1
------------------
RecID
CustName
Table2
-------------------
RecID
Name
Description
Picture
Query Case:
-------------------
I need a query to get all the pictures from Table2 where the Table2.Name = Table1.CustName ordered by Table2.Description ASC.
VB Case:
----------------
When I get the pictures in the query, they should appear listed by description in a listbox, and when I click on a name in the listbox I should be able to see the picture in a imagebox. Only the images from the selected custommer should appear in the listbox.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|