Simple Query Question

Hello Group,

I'm new to SQL sever but I have managed to create a SQL based online
application and I just have a question that I'm sure someone here will
be able to help me with.

I have a database setup and from within this database I would like to
run a query to produce a simple report showing me the enquiry details
along with the network the enquiry member is from.

Tables:

1 - dbo.enquiries

enquiryID
introducerID
enquiry


2 - dbo.introducers
introducerID
networkName
introducerName

What I would like is a report where I can view new enquiries from
introducers from a particular network, best described as follows:

View all enquiries from introducers who belong to 'Network Name' which
were created within the last 30 days.

I think that I have to create an inner join but Im not 100% so any
help including the correct sql statement to use would be perfect.

Many thanks in advance

Lee
.

Relevant Pages

  • Re: SQL Server mobile 2005 Stored Procs and triggers
    ... enquiry, this is a very prevalent belief w/ Sql ... Mobile and i was curious as to where it's originated. ... >I know stored procs are supported in SQL Mobile but are Triggers supported ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Simple Query Question
    ... What column in your tables has the date value when the enquiry was created? ... You need that date to be able to report those that were created in the last 30 days. ... WHERE I.networkName = 'Network Name' ... Plamen Ratchev ...
    (comp.databases.ms-sqlserver)