User Profile

Collapse

Profile Sidebar

Collapse
Idrisu
Idrisu
Last Activity: Jan 14 '10, 04:28 AM
Joined: Dec 26 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Idrisu
    replied to Howto get multiple wheres on one column
    in MySQL
    It worked!

    Thank you for the great answer.
    After seeing your sql-statements i realize that i'm a total noob on sql ;)

    I found also one solution:

    Select tableA.id1 from (
    Select tableA.id1 as id1A from tableA inner join tableB on (tableA.id1 = tableB.id1) inner join tableC on (tableB.id2 = tableC.id2) where tableC.name = "Name1") as a
    inner join (
    Select tableA.id1...
    See more | Go to post

      Leave a comment:

    • Idrisu
      started a topic Howto get multiple wheres on one column
      in MySQL

      Howto get multiple wheres on one column

      Hello,

      i have this constellation on tables in my database:

      Table A
      id|content

      Table B
      table_a_id|tabl e_c_id

      Table C
      id|name

      My question is:
      How to write a select like this:
      Select content from table_a inner join table_b on (table_a.id = table_b.table_a _id)
      inner join table c on (table_b.table_ c_id = table_c.id)
      Where name =...
      See more | Go to post
      No activity results to display
      Show More
      Working...