database join

I want to query across two tables: members and payments . One member record could join with many payments. However, I need each payment record to be…

having a little trouble with this query. I have two tables ... Account - ResourceID (int) AccountID (int) (unique auto-inc) Resource - TextName…

I have to database tables, where entities of the first Table may or may not have associated entries in the second table: Table 1 Table 2…

I have my project A with mySql database and I have another project B with msSql. I have connected the database from A and fetched data from B. But…

I'm using this query to fetch all tasks with a specific tag in a HABTM relationship. However for some reason it is failing to attach relevant tags…

I have follow tables: |ELEMENTS| ------------ |id_element| |id_catalog| |value| |CATALOG| ------------ |id_catalog| |catalog_name| |show| |status| I…

The situation: I have MySQL 5. I am trying to produce a report of companies and some profit details. Each company has jobs that we do for them. Each…

Hi, I have this join: select first_name, last_name, photo_path, private_messages, mid_thumb, bio_blurb, user_email from users left join member_photo…

Hi, Supposed I have the following tables -- smallville=# create table contacts (name varchar(16), address_id int); CREATE TABLE smallville=# create…

I need to use classes to represent entities in database, here are some information: === TABLEs === SHOP shop_id(primary) name owner FAVOURITES LIST…

Hello, I have three MySQL tables which relate to a messaging system. The schema and sample data is shown below for each table relating to my…

Lets say you have 2 doc types.... customers and orders. Customer doc contains basic info... name, address etc. and then orders contain all the order…

hi guys, I know that you can do join statements on SELECT, but can you also do joins using UPDATE, INSERT, and DELETE statements so that rows from…

I have two tables that I'm joining (in order to get the username from, I'm joining them both on user_id). Here is my Accounts table structure:…

Apologies if the title is ambiguous, but I could not figure out a good way to title this problem. In my database, I have a table J that joins tables…

Are there any mySQL frontends, like phpmyadmin, that has a graphical interface for joins? I know you can run saved queries (which may include joins)…

Let's imagine we have two tables: Users (UserId, UserName, UserPhoto) and Articles (ArticleId, UserId, ArticleText). Now we execute inner join query…

Hey Guys, i have a problem and at that point no clue or starting point how to fix: I have three Tables with the following fields (i have limited to…

I'm pretty sure that I need to be doing left outer joins on my tables, but i'm not sure if that is 100% true or the syntax to write them in mySQL. I…

Here is an simple example for my problem: CREATE TABLE test1 (id SERIAL, key TEXT UNIQUE, value TEXT); CREATE TABLE test2 (id SERIAL, key TEXT…