programming

[carpediem]

^ syntax error ata sa part ng

innerjoin 'Jean' from friends
innerjoin 'Maria' from friends

@darkstar: COBOL much?

[marvinofthefaintsmile]

^^ CORRECT!! You have a gud eye ah. Hehehehehehe!!

[carpediem]

inner join?

what about left outer join, right outer join, full outer join, cross join, natural join?

what about union and intersect?

lol

[Hitad]

Kinakabahan ako sa job application ko. Sana matanggap ako, I need to force myself in getting used to OOP.
I usually do procedural programming kasi dati...

[marvinofthefaintsmile]

inner join?

what about left outer join, right outer join, full outer join, cross join, natural join?

what about union and intersect?

lol

what about shape?

[Hitad]

May web developers ba dito? I need tips for an entry level applicant like me +_+_+_+_+

[carpediem]

@marvs - anong shape?

@hitad - anong tips kailangan mo? hehe

[marvinofthefaintsmile]

^^ pinakamahirap na ADO command na ginamit q 6 years ago.., I'm not using SQL today na.., mejo 'higher' view na kase ang gngwa q.. No programming anymore for me., more of documentations and analysis na lang ang task q ngyon..,

Simplified Syntax
   SHAPE {parent-statement}
   APPEND Aggregate
        | ({child-statement} [As Alias]
          RELATE parent-field TO child-field | parameter-marker
                 [, parent-field TO child-field | parameter-marker ...])
          [, Aggregate | ({child statement})...]

   SHAPE {non-normalized-statement} [AS Alias]
   COMPUTE Aggregate
         | Alias
         | ({child-statement} [As Alias] RELATE parent-field TO
                                        child-field | parameter-marker)
           [, Aggregate | Alias | ({child-statement}...)]
   [BY grouping-field [, grouping-field]]

   SHAPE {non-normalized-statement} [AS Alias]
   BY grouping-field [, grouping-field]

[maykel]

SELECT 'Fin' FROM Friends INNERJOIN 'Jean' FROM Friends WHERE Sex=True INNERJOIN 'Maria' FROM Friends WHERE Sex=True;

^^ Threesome?

EROTIC SQL.

Wrong syntax in general...

-INNERJOIN should be "inner join".
-Two "FROM"  wherein I can only see one "SELECT".
-Missing "ON" from "Inner Join"
- Out put is incorrect. the output should be "Fin" because you already a possible output using SELECT 'Fin'

OOOPPPSSSSS
Quoted:

EROTIC SQL.

a new version of SQL...

Sorry kung daming puna but I value this thread personally because I think this particular thread will help a soon to be programmer.

[maykel]

@marvs - anong shape?

@hitad - anong tips kailangan mo? hehe

Shape - use for hierarchical recordset.

Shape is explained in this site: http://support.microsoft.com/kb/189657

[carpediem]

^ Hopefully this thread could help a newbie, however with the way we joke, baka ma-confuse pa hehehe 

I see. So Shape is an ADO command, not really SQL.

[maykel]

^ Hopefully this thread could help a newbie, however with the way we joke, baka ma-confuse pa hehehe 

I see. So Shape is an ADO command, not really SQL.

yup. pero hindi na ata sya supported ng recent programming language.

[maykel]

May web developers ba dito? I need tips for an entry level applicant like me +_+_+_+_+

Tip.... maging familiar ka muna sa OOP.
anung language ba ang gusto mong gamitin?

[Hitad]

May web developers ba dito? I need tips for an entry level applicant like me +_+_+_+_+

Tip.... maging familiar ka muna sa OOP.
anung language ba ang gusto mong gamitin?

I meant to say share infos please. Sorry. Just want to ask kung ano gagawin sa commencement term ng isang beginner sa company? Kung ano yung pinagagawa sa mga new employees during their training?

[maykel]

uhhmmm..
Ako kasi, since hindi pa ako ganun kaconfident sa skills ko sa programming, naghanap ako ng opening na may provided na training. In that case eh mas maeenhance pa ang skills ko.
With regards naman sa pagaapply, dapat may alam ka na kahit konti dun sa inaaplyan mo.

paxenxa na hirap kasi akong magadvice dahil hindi ko alam ang current situation mo.