Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Search:

Type: Posts; User: window2

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    1,210

    I used a small program called AccessDump...

    I used a small program called AccessDump (accessdump.com) and it creates an file/code upon export from Access you can use to dump the data into MySQL. VERY simple. Check out their site and you will...
  2. Replies
    1
    Views
    849

    I need something rather unique... I have an...

    I need something rather unique...
    I have an older table with data like this:

    Table Name:
    table1

    Column names:

    PropertyID
    Field
  3. Replies
    5
    Views
    1,205

    Third party had answer... select t1.ID ...

    Third party had answer...


    select t1.ID
    , t1.name
    from table1 as t1
    left outer
    join table2 as t2
    on t1.name = t2.name
    and t2.answer = 'yes'
  4. Replies
    5
    Views
    1,205

    Rosland, Close on the second one... I want...

    Rosland,

    Close on the second one...

    I want the records from the first table that
    EITHER...
    do not have a record in the second table YET,
    OR have a record but it's Table2.answer value is 'no'...
  5. Replies
    5
    Views
    1,205

    Here is a simple example of the set up: Table1...

    Here is a simple example of the set up:

    Table1 (table name)
    ID (field name in Table1)
    name (field name in Table1)

    Table2 (second table name)
    name (field name in Table2)
    answer (field name...
Results 1 to 5 of 5
All times are GMT -6. The time now is 02:08 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com