my code stock.com

mburknoe

MySQL Join two rows results
by mburknoe

This is designed to join two rows of a DB together as one.
In this case we are joining the basic main account info with account credit card info.

Snippet options

Download: Download snippet as mysql-join-two-rows-results.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

SELECT m.`accountid`, m.`firstname`, m.`lastname`, 
	c.stripe_id, c.last4, c.exp_year, c.exp_month, c.active
	FROM `account_main` AS m
	INNER JOIN `account_cc` AS c 
	ON m.accountid = c.accountid
	WHERE m.`status` = 'Active' 
	AND m.`billnext` >= '2013-01-01' 
	AND m.`billnext` <= '2013-01-28';

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.