User Profile

Collapse

Profile Sidebar

Collapse
GottZ
GottZ
Last Activity: May 29 '10, 12:44 PM
Joined: May 21 '10
Location: Germany
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • GottZ
    replied to two unusual tables, one query
    in MySQL
    i have it done now.
    Code:
    SELECT
	`tmp`.`name`,
	`tmp`.`somethingelse`,
	`tmp`.`concount`
FROM
	(
		SELECT
			`NAMES`.`name` AS 'name',
			`USER`.`somethingelse` AS 'somethingelse',
			`USER`.`concount` AS 'concount',
			`USER`.`uid` AS 'uid'
		FROM
			`DB`.`USER`
		LEFT JOIN
			`DB`.`NAMES`
		ON
			`USER`.`uid` = `NAMES`.`uid`
		ORDER BY
    ...
    See more | Go to post
    Last edited by GottZ; May 22 '10, 10:50 AM. Reason: changed the sql

      Leave a comment:

    • GottZ
      started a topic two unusual tables, one query
      in MySQL

      two unusual tables, one query

      hello there,

      i'm a SQL newbie and could need some advice.

      i'll show you now some abstracted tables and an explaining of what i'm going to do with them.
      i truly hope its not that ugly written as i think.
      besides this is the first time i ever ask for SQL help.
      so please don't go at me like i've never read a documentation.

      i'm having theese two tables:
      Code:
      +----------------+
|      USER
      ...
      See more | Go to post
      • GottZ
        replied to What is the best practice for storing data in multiple time zones?
        in DB2
        what language are you using?
        php?
        unix timestamps?
        if php, then do you know that php comes with some neat date functions to handle that kind of problem?
        See more | Go to post

          Leave a comment:

        No activity results to display
        Show More
        Working...