SQL delete unrelated records

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello

Lets say i have 2 tables t1 and t2 and they are related (inner join) by ID
and t1_ID respectivley, 1 to many respectivley..

Now, lets sey they are records in column ID that aren't related to any t1_ID
column. How do i write the SQL syntax to show those that are related to
nothing.

Any suggestion is appreciated.

Greets
Davor
.

Relevant Pages

  • Re: WHAT DO I USE TO MAKE A TODAY DATE QUERY?
    ... Microsoft made the sql syntax for Access different ... than msSQL. ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: stored procedure
    ... Error 1064 #42000You have an error in your SQL syntax; ... corresponds to your MySQL server version for the right syntax to use near ... Dim conn As New MySql.Data.MySqlClient.MySqlConnection ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Sey facemasked him...
    ... > ...but the stripeys somehow missed the fact that Sey was held on the way ... he could make the play ... Prev by Date: ...
    (alt.sports.football.pro.ne-patriots)
  • Having problem with simple "NOT IN" query
    ... #1064 - You have an error in your SQL syntax. ... corresponds to your MySQL server version for the right syntax to use ... Manny ... Prev by Date: ...
    (comp.databases.ingres)
  • Re: Creating a new table
    ... The SQL syntax for CREATE TABLE is ... So, if we are to create the customer table specified as above, we may type ... > How do I create a table from an sql command? ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)